package com.ffox.mapper;

import com.ffox.entity.ClassTeacher;
import com.ffox.entity.Clazz;
import com.ffox.entity.StudentInformation;
import com.ffox.entity.Teachers;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface SchoolStudentMapper {
//    根据学校id查询所有班级
    public List<Clazz> getClassBySchoolId(String schoolNum);
//    根据教师id查询教师信息
    public List<Teachers> getTeacherBySchoolNum(String schoolNum);
//    根据班级id查询学生列表
    public List<StudentInformation> getStudentListByClassId(Long classId);
//    根据学生学籍号查询学校id
    public Long getSchoolIdByStudentIdCard(String studentIdCard);
//    增加班级
    public Integer addClass(Clazz classInfo);
//    根据学籍号修改学生列表的班级
    public Integer updateStudentClass(@Param("studentIdCard") String studentIdCard, @Param("classId") Long classId);

    public Integer updateClass(Long classId, Map<String, Object> params);

    public Integer deleteClass(Long classId);

    public List<ClassTeacher> getClassTeacherListByClassId(Long classId);

    public Integer addClassTeacher(ClassTeacher classTeacher);

    public Integer updateClassTeacher(ClassTeacher classTeacher);

    public ClassTeacher getClassTeacherByClassIdAndCourseId(@Param("classId") Long classId, @Param("courseName") String courseName);
}
